﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="Assignments" targetNamespace="http://tempuri.org/Assignments.xsd" xmlns:mstns="http://tempuri.org/Assignments.xsd" xmlns="http://tempuri.org/Assignments.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Web.config" AppSettingsPropertyName="ILEConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="ILEConnectionString (Web.config)" ParameterPrefix="@" PropertyReference="AppConfig.System.Configuration.ConfigurationManager.0.ConnectionStrings.ILEConnectionString.ConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AssignmentsTableAdapter" GeneratorDataComponentClassName="AssignmentsTableAdapter" Name="Assignments" UserDataComponentName="AssignmentsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectName="dbo.Assignments" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillAssignments" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetAssignments" GeneratorSourceName="FillAssignments" GetMethodModifier="Public" GetMethodName="GetAssignments" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetAssignments" UserSourceName="FillAssignments">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [Assignments] WHERE (([AssignmentID] = @Original_AssignmentID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_AssignmentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AssignmentID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [Assignments] ([AssignmentType], [AssignmentTitle], [Instruction], [SendNotifyStart], [SendNotifyEnd], [SendNotifyEndHours], [SendResult], [TimeStamp], [StartDateTime], [EndDateTime]) VALUES (@AssignmentType, @AssignmentTitle, @Instruction, @SendNotifyStart, @SendNotifyEnd, @SendNotifyEndHours, @SendResult, @TimeStamp, @StartDateTime, @EndDateTime)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@AssignmentType" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AssignmentType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@AssignmentTitle" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AssignmentTitle" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Instruction" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="Instruction" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@SendNotifyStart" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="SendNotifyStart" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@SendNotifyEnd" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="SendNotifyEnd" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SendNotifyEndHours" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SendNotifyEndHours" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@SendResult" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="SendResult" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@TimeStamp" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="TimeStamp" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@StartDateTime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="StartDateTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@EndDateTime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EndDateTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     Assignments.*
FROM         Assignments</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [Assignments] SET [AssignmentType] = @AssignmentType, [AssignmentTitle] = @AssignmentTitle, [Instruction] = @Instruction, [SendNotifyStart] = @SendNotifyStart, [SendNotifyEnd] = @SendNotifyEnd, [SendNotifyEndHours] = @SendNotifyEndHours, [SendResult] = @SendResult, [TimeStamp] = @TimeStamp, [StartDateTime] = @StartDateTime, [EndDateTime] = @EndDateTime WHERE (([AssignmentID] = @Original_AssignmentID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@AssignmentType" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AssignmentType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@AssignmentTitle" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AssignmentTitle" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Instruction" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="Instruction" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@SendNotifyStart" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="SendNotifyStart" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@SendNotifyEnd" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="SendNotifyEnd" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SendNotifyEndHours" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SendNotifyEndHours" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@SendResult" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="SendResult" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@TimeStamp" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="TimeStamp" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@StartDateTime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="StartDateTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@EndDateTime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EndDateTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_AssignmentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AssignmentID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="AssignmentID" DataSetColumn="AssignmentID" />
              <Mapping SourceColumn="AssignmentType" DataSetColumn="AssignmentType" />
              <Mapping SourceColumn="AssignmentTitle" DataSetColumn="AssignmentTitle" />
              <Mapping SourceColumn="Instruction" DataSetColumn="Instruction" />
              <Mapping SourceColumn="SendNotifyStart" DataSetColumn="SendNotifyStart" />
              <Mapping SourceColumn="SendNotifyEnd" DataSetColumn="SendNotifyEnd" />
              <Mapping SourceColumn="SendNotifyEndHours" DataSetColumn="SendNotifyEndHours" />
              <Mapping SourceColumn="SendResult" DataSetColumn="SendResult" />
              <Mapping SourceColumn="TimeStamp" DataSetColumn="TimeStamp" />
              <Mapping SourceColumn="StartDateTime" DataSetColumn="StartDateTime" />
              <Mapping SourceColumn="EndDateTime" DataSetColumn="EndDateTime" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectName="dbo.Assignments" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillAssignmentByAssignmentID" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetAssignmentByAssignmentID" GeneratorSourceName="FillAssignmentByAssignmentID" GetMethodModifier="Public" GetMethodName="GetAssignmentByAssignmentID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetAssignmentByAssignmentID" UserSourceName="FillAssignmentByAssignmentID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     Assignments.*
FROM         Assignments
WHERE AssignmentID = @AssignmentID</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="AssignmentID" ColumnName="AssignmentID" DataSourceName="[E:\WORKSPACE\ILE\APP_DATA\ILE.MDF].dbo.Assignments" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@AssignmentID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="AssignmentID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectName="dbo.Assignments" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillAssignmentsByAssignmentType" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetAssignmentsByAssignmentType" GeneratorSourceName="FillAssignmentsByAssignmentType" GetMethodModifier="Public" GetMethodName="GetAssignmentsByAssignmentType" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetAssignmentsByAssignmentType" UserSourceName="FillAssignmentsByAssignmentType">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     AssignmentID, AssignmentType, AssignmentTitle, Instruction, SendNotifyStart, SendNotifyEnd, SendNotifyEndHours, SendResult, TimeStamp, 
                      StartDateTime, EndDateTime
FROM         Assignments
WHERE     (AssignmentType = @AssignmentType)
ORDER BY EndDateTime</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="AssignmentType" ColumnName="AssignmentType" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\DESKTOP\MY DROPBOX\WORK\LIDEV\APP_DATA\ILE.MDF].dbo.Assignments" DataTypeServer="varchar(10)" DbType="AnsiString" Direction="Input" ParameterName="@AssignmentType" Precision="0" ProviderType="VarChar" Scale="0" Size="10" SourceColumn="AssignmentType" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="InsertAssignment" Modifier="Public" Name="InsertAssignment" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="InsertAssignment">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>INSERT INTO [Assignments] ([AssignmentType], [AssignmentTitle], [Instruction], [SendNotifyStart], [SendNotifyEnd], [SendNotifyEndHours], [SendResult], [TimeStamp], [StartDateTime], [EndDateTime]) VALUES (@AssignmentType, @AssignmentTitle, @Instruction, @SendNotifyStart, @SendNotifyEnd, @SendNotifyEndHours, @SendResult, @TimeStamp, @StartDateTime, @EndDateTime)
;
SELECT SCOPE_IDENTITY()</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="AssignmentType" ColumnName="AssignmentType" DataSourceName="[E:\WORKSPACE\ILE\APP_DATA\ILE.MDF].dbo.Assignments" DataTypeServer="varchar(10)" DbType="AnsiString" Direction="Input" ParameterName="@AssignmentType" Precision="0" ProviderType="VarChar" Scale="0" Size="10" SourceColumn="AssignmentType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="AssignmentTitle" ColumnName="AssignmentTitle" DataSourceName="[E:\WORKSPACE\ILE\APP_DATA\ILE.MDF].dbo.Assignments" DataTypeServer="varchar(100)" DbType="AnsiString" Direction="Input" ParameterName="@AssignmentTitle" Precision="0" ProviderType="VarChar" Scale="0" Size="100" SourceColumn="AssignmentTitle" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Instruction" ColumnName="Instruction" DataSourceName="[E:\WORKSPACE\ILE\APP_DATA\ILE.MDF].dbo.Assignments" DataTypeServer="text" DbType="AnsiString" Direction="Input" ParameterName="@Instruction" Precision="0" ProviderType="Text" Scale="0" Size="2147483647" SourceColumn="Instruction" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="SendNotifyStart" ColumnName="SendNotifyStart" DataSourceName="[E:\WORKSPACE\ILE\APP_DATA\ILE.MDF].dbo.Assignments" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@SendNotifyStart" Precision="0" ProviderType="Bit" Scale="0" Size="1" SourceColumn="SendNotifyStart" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="SendNotifyEnd" ColumnName="SendNotifyEnd" DataSourceName="[E:\WORKSPACE\ILE\APP_DATA\ILE.MDF].dbo.Assignments" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@SendNotifyEnd" Precision="0" ProviderType="Bit" Scale="0" Size="1" SourceColumn="SendNotifyEnd" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="SendNotifyEndHours" ColumnName="SendNotifyEndHours" DataSourceName="[E:\WORKSPACE\ILE\APP_DATA\ILE.MDF].dbo.Assignments" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@SendNotifyEndHours" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="SendNotifyEndHours" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="SendResult" ColumnName="SendResult" DataSourceName="[E:\WORKSPACE\ILE\APP_DATA\ILE.MDF].dbo.Assignments" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@SendResult" Precision="0" ProviderType="Bit" Scale="0" Size="1" SourceColumn="SendResult" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="TimeStamp" ColumnName="TimeStamp" DataSourceName="[E:\WORKSPACE\ILE\APP_DATA\ILE.MDF].dbo.Assignments" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@TimeStamp" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="TimeStamp" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="StartDateTime" ColumnName="StartDateTime" DataSourceName="[E:\WORKSPACE\ILE\APP_DATA\ILE.MDF].dbo.Assignments" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@StartDateTime" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="StartDateTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="EndDateTime" ColumnName="EndDateTime" DataSourceName="[E:\WORKSPACE\ILE\APP_DATA\ILE.MDF].dbo.Assignments" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@EndDateTime" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="EndDateTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="QuizAssignmentsTableAdapter" GeneratorDataComponentClassName="QuizAssignmentsTableAdapter" Name="QuizAssignments" UserDataComponentName="QuizAssignmentsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="FillQuizAssignment" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetQuizAssignment" GeneratorSourceName="FillQuizAssignment" GetMethodModifier="Public" GetMethodName="GetQuizAssignment" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetQuizAssignment" UserSourceName="FillQuizAssignment">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     Assignments.AssignmentID, Assignments.AssignmentType, Assignments.AssignmentTitle, Assignments.Instruction, Assignments.SendNotifyStart, 
                      Assignments.SendNotifyEnd, Assignments.SendNotifyEndHours, Assignments.SendResult, Assignments.TimeStamp, Assignments.StartDateTime, 
                      Assignments.EndDateTime, Assignments_Quiz.QuizAssignment, Assignments_Quiz.MaximumAttempts, Assignments_Quiz.NumberOfQuestions
FROM         Assignments INNER JOIN
                      Assignments_Quiz ON Assignments.AssignmentID = Assignments_Quiz.AssignmentID
WHERE Assignments_Quiz.AssignmentID = @AssignmentID</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="AssignmentID" ColumnName="AssignmentID" DataSourceName="[E:\WORKSPACE\ILE\APP_DATA\ILE.MDF].dbo.Assignments_Quiz" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@AssignmentID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="AssignmentID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="AssignmentID" DataSetColumn="AssignmentID" />
              <Mapping SourceColumn="QuizAssignment" DataSetColumn="QuizAssignment" />
              <Mapping SourceColumn="MaximumAttempts" DataSetColumn="MaximumAttempts" />
              <Mapping SourceColumn="AssignmentType" DataSetColumn="AssignmentType" />
              <Mapping SourceColumn="AssignmentTitle" DataSetColumn="AssignmentTitle" />
              <Mapping SourceColumn="Instruction" DataSetColumn="Instruction" />
              <Mapping SourceColumn="SendNotifyStart" DataSetColumn="SendNotifyStart" />
              <Mapping SourceColumn="SendNotifyEnd" DataSetColumn="SendNotifyEnd" />
              <Mapping SourceColumn="SendNotifyEndHours" DataSetColumn="SendNotifyEndHours" />
              <Mapping SourceColumn="SendResult" DataSetColumn="SendResult" />
              <Mapping SourceColumn="TimeStamp" DataSetColumn="TimeStamp" />
              <Mapping SourceColumn="StartDateTime" DataSetColumn="StartDateTime" />
              <Mapping SourceColumn="EndDateTime" DataSetColumn="EndDateTime" />
              <Mapping SourceColumn="NumberOfQuestions" DataSetColumn="NumberOfQuestions" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="RelationsTableAdapter" GeneratorDataComponentClassName="RelationsTableAdapter" Name="Relations" UserDataComponentName="RelationsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectName="dbo.[Relations_Assignments-Courses_Section]" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillRelations" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetRelations" GeneratorSourceName="FillRelations" GetMethodModifier="Public" GetMethodName="GetRelations" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetRelations" UserSourceName="FillRelations">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [Relations_Assignments-Courses_Section] WHERE (([AssignmentID] = @Original_AssignmentID) AND ([CourseID] = @Original_CourseID) AND ([SectionNumber] = @Original_SectionNumber) AND ([StandardID] = @Original_StandardID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_AssignmentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AssignmentID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CourseID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CourseID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SectionNumber" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SectionNumber" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_StandardID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StandardID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [Relations_Assignments-Courses_Section] ([AssignmentID], [CourseID], [SectionNumber], [StandardID]) VALUES (@AssignmentID, @CourseID, @SectionNumber, @StandardID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AssignmentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AssignmentID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CourseID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CourseID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SectionNumber" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SectionNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@StandardID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StandardID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     [Relations_Assignments-Courses_Section].*
FROM         [Relations_Assignments-Courses_Section]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [Relations_Assignments-Courses_Section] SET [AssignmentID] = @AssignmentID, [CourseID] = @CourseID, [SectionNumber] = @SectionNumber, [StandardID] = @StandardID WHERE (([AssignmentID] = @Original_AssignmentID) AND ([CourseID] = @Original_CourseID) AND ([SectionNumber] = @Original_SectionNumber) AND ([StandardID] = @Original_StandardID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AssignmentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AssignmentID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CourseID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CourseID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SectionNumber" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SectionNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@StandardID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StandardID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_AssignmentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AssignmentID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CourseID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CourseID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SectionNumber" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SectionNumber" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_StandardID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StandardID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="AssignmentID" DataSetColumn="AssignmentID" />
              <Mapping SourceColumn="CourseID" DataSetColumn="CourseID" />
              <Mapping SourceColumn="SectionNumber" DataSetColumn="SectionNumber" />
              <Mapping SourceColumn="StandardID" DataSetColumn="StandardID" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="DeleteRelationsByAssignmentID" Modifier="Public" Name="DeleteRelationsByAssignmentID" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="DeleteRelationsByAssignmentID">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>DELETE FROM [Relations_Assignments-Courses_Section]
WHERE     (AssignmentID = @Original_AssignmentID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Original_AssignmentID" ColumnName="AssignmentID" DataSourceName="[E:\WORKSPACE\ILE\APP_DATA\ILE.MDF].dbo.[Relations_Assignments-Courses_Section]" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_AssignmentID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="AssignmentID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
              </DbSource>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectName="dbo.[Relations_Assignments-Courses_Section]" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillRelation" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetRelation" GeneratorSourceName="FillRelation" GetMethodModifier="Public" GetMethodName="GetRelation" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetRelation" UserSourceName="FillRelation">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     [Relations_Assignments-Courses_Section].*
FROM         [Relations_Assignments-Courses_Section]
WHERE AssignmentID = @AssignmentID AND CourseID = @CourseID AND SectionNumber = @SectionNumber AND StandardID = @StandardID</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="AssignmentID" ColumnName="AssignmentID" DataSourceName="[E:\WORKSPACE\ILE\APP_DATA\ILE.MDF].dbo.[Relations_Assignments-Courses_Section]" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@AssignmentID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="AssignmentID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="CourseID" ColumnName="CourseID" DataSourceName="[E:\WORKSPACE\ILE\APP_DATA\ILE.MDF].dbo.[Relations_Assignments-Courses_Section]" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@CourseID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="CourseID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="SectionNumber" ColumnName="SectionNumber" DataSourceName="[E:\WORKSPACE\ILE\APP_DATA\ILE.MDF].dbo.[Relations_Assignments-Courses_Section]" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@SectionNumber" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="SectionNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="StandardID" ColumnName="StandardID" DataSourceName="[E:\WORKSPACE\ILE\APP_DATA\ILE.MDF].dbo.[Relations_Assignments-Courses_Section]" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@StandardID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="StandardID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectName="dbo.[Relations_Assignments-Courses_Section]" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillRelationsByAssignmentID" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetRelationsByAssignmentID" GeneratorSourceName="FillRelationsByAssignmentID" GetMethodModifier="Public" GetMethodName="GetRelationsByAssignmentID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetRelationsByAssignmentID" UserSourceName="FillRelationsByAssignmentID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     [Relations_Assignments-Courses_Section].*
FROM         [Relations_Assignments-Courses_Section]
WHERE AssignmentID = @AssignmentID</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="AssignmentID" ColumnName="AssignmentID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\DESKTOP\MY DROPBOX\WORK\LIDEV\APP_DATA\ILE.MDF].dbo.[Relations_Assignments-Courses_Section]" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@AssignmentID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="AssignmentID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectName="dbo.[Relations_Assignments-Courses_Section]" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillRelationsByCourseID" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetRelationsByCourseID" GeneratorSourceName="FillRelationsByCourseID" GetMethodModifier="Public" GetMethodName="GetRelationsByCourseID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetRelationsByCourseID" UserSourceName="FillRelationsByCourseID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     [Relations_Assignments-Courses_Section].*
FROM         [Relations_Assignments-Courses_Section]
WHERE CourseID = @CourseID</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="CourseID" ColumnName="CourseID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\DESKTOP\ILE RC1\APP_DATA\ILE.MDF].dbo.[Relations_Assignments-Courses_Section]" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@CourseID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="CourseID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectName="dbo.[Relations_Assignments-Courses_Section]" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillRelationsByCourseIdAndSectionNumber" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetRelationsByCourseIdAndSectionNumber" GeneratorSourceName="FillRelationsByCourseIdAndSectionNumber" GetMethodModifier="Public" GetMethodName="GetRelationsByCourseIdAndSectionNumber" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetRelationsByCourseIdAndSectionNumber" UserSourceName="FillRelationsByCourseIdAndSectionNumber">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     [Relations_Assignments-Courses_Section].*
FROM         [Relations_Assignments-Courses_Section]
WHERE CourseID = @CourseID AND SectionNumber = @SectionNumber</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="CourseID" ColumnName="CourseID" DataSourceName="[E:\WORKSPACE\ILE\APP_DATA\ILE.MDF].dbo.[Relations_Assignments-Courses_Section]" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@CourseID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="CourseID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="SectionNumber" ColumnName="SectionNumber" DataSourceName="[E:\WORKSPACE\ILE\APP_DATA\ILE.MDF].dbo.[Relations_Assignments-Courses_Section]" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@SectionNumber" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="SectionNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectName="dbo.[Relations_Assignments-Courses_Section]" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillRelationsByCourseIdAndSectionNumberAndStandardId" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetRelationsByCourseIdAndSectionNumberAndStandardId" GeneratorSourceName="FillRelationsByCourseIdAndSectionNumberAndStandardId" GetMethodModifier="Public" GetMethodName="GetRelationsByCourseIdAndSectionNumberAndStandardId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetRelationsByCourseIdAndSectionNumberAndStandardId" UserSourceName="FillRelationsByCourseIdAndSectionNumberAndStandardId">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     [Relations_Assignments-Courses_Section].*
FROM         [Relations_Assignments-Courses_Section]
WHERE CourseID = @CourseID AND SectionNumber=@SectionNumber AND StandardID = @StandardID</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="CourseID" ColumnName="CourseID" DataSourceName="[E:\WORKSPACE\ILE\APP_DATA\ILE.MDF].dbo.[Relations_Assignments-Courses_Section]" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@CourseID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="CourseID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="SectionNumber" ColumnName="SectionNumber" DataSourceName="[E:\WORKSPACE\ILE\APP_DATA\ILE.MDF].dbo.[Relations_Assignments-Courses_Section]" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@SectionNumber" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="SectionNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="StandardID" ColumnName="StandardID" DataSourceName="[E:\WORKSPACE\ILE\APP_DATA\ILE.MDF].dbo.[Relations_Assignments-Courses_Section]" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@StandardID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="StandardID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectName="dbo.[Relations_Assignments-Courses_Section]" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillRelationsByCourseIdAndStandardId" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetRelationsByCourseIdAndStandardId" GeneratorSourceName="FillRelationsByCourseIdAndStandardId" GetMethodModifier="Public" GetMethodName="GetRelationsByCourseIdAndStandardId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetRelationsByCourseIdAndStandardId" UserSourceName="FillRelationsByCourseIdAndStandardId">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     [Relations_Assignments-Courses_Section].*
FROM         [Relations_Assignments-Courses_Section]
WHERE CourseID = @CourseID AND StandardID = @StandardID</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="CourseID" ColumnName="CourseID" DataSourceName="[E:\WORKSPACE\ILE\APP_DATA\ILE.MDF].dbo.[Relations_Assignments-Courses_Section]" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@CourseID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="CourseID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="StandardID" ColumnName="StandardID" DataSourceName="[E:\WORKSPACE\ILE\APP_DATA\ILE.MDF].dbo.[Relations_Assignments-Courses_Section]" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@StandardID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="StandardID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy" GeneratorSourceName="IsDuplicated" Modifier="Public" Name="IsDuplicated" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="IsDuplicated">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT COUNT(*) FROM [Relations_Assignments-Courses_Section]
WHERE CourseID = @CourseID AND SectionNumber = @SectionNumber AND StandardID = @StandardID</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="CourseID" ColumnName="CourseID" DataSourceName="[E:\WORKSPACE\ILE\APP_DATA\ILE.MDF].dbo.[Relations_Assignments-Courses_Section]" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@CourseID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="CourseID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="SectionNumber" ColumnName="SectionNumber" DataSourceName="[E:\WORKSPACE\ILE\APP_DATA\ILE.MDF].dbo.[Relations_Assignments-Courses_Section]" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@SectionNumber" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="SectionNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="StandardID" ColumnName="StandardID" DataSourceName="[E:\WORKSPACE\ILE\APP_DATA\ILE.MDF].dbo.[Relations_Assignments-Courses_Section]" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@StandardID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="StandardID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Assignments_QuizTableAdapter" GeneratorDataComponentClassName="Assignments_QuizTableAdapter" Name="Assignments_Quiz" UserDataComponentName="Assignments_QuizTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectName="dbo.Assignments_Quiz" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillQuizAssignments" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetQuizAssignments" GeneratorSourceName="FillQuizAssignments" GetMethodModifier="Public" GetMethodName="GetQuizAssignments" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetQuizAssignments" UserSourceName="FillQuizAssignments">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [Assignments_Quiz] WHERE (([AssignmentID] = @Original_AssignmentID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_AssignmentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AssignmentID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [Assignments_Quiz] ([AssignmentID], [QuizAssignment], [MaximumAttempts], [NumberOfQuestions]) VALUES (@AssignmentID, @QuizAssignment, @MaximumAttempts, @NumberOfQuestions)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AssignmentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AssignmentID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@QuizAssignment" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="QuizAssignment" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MaximumAttempts" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MaximumAttempts" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@NumberOfQuestions" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NumberOfQuestions" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     Assignments_Quiz.*
FROM         Assignments_Quiz</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [Assignments_Quiz] SET [AssignmentID] = @AssignmentID, [QuizAssignment] = @QuizAssignment, [MaximumAttempts] = @MaximumAttempts, [NumberOfQuestions] = @NumberOfQuestions WHERE (([AssignmentID] = @Original_AssignmentID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AssignmentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AssignmentID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@QuizAssignment" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="QuizAssignment" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MaximumAttempts" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MaximumAttempts" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@NumberOfQuestions" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NumberOfQuestions" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_AssignmentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AssignmentID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="AssignmentID" DataSetColumn="AssignmentID" />
              <Mapping SourceColumn="QuizAssignment" DataSetColumn="QuizAssignment" />
              <Mapping SourceColumn="MaximumAttempts" DataSetColumn="MaximumAttempts" />
              <Mapping SourceColumn="NumberOfQuestions" DataSetColumn="NumberOfQuestions" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectName="dbo.Assignments_Quiz" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillQuizAssignment" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetQuizAssignment" GeneratorSourceName="FillQuizAssignment" GetMethodModifier="Public" GetMethodName="GetQuizAssignment" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetQuizAssignment" UserSourceName="FillQuizAssignment">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     Assignments_Quiz.*
FROM         Assignments_Quiz
WHERE AssignmentID = @AssignmentID</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="AssignmentID" ColumnName="AssignmentID" DataSourceName="[E:\WORKSPACE\ILE\APP_DATA\ILE.MDF].dbo.Assignments_Quiz" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@AssignmentID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="AssignmentID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Assignments_Submission_QuizTableAdapter" GeneratorDataComponentClassName="Assignments_Submission_QuizTableAdapter" Name="Assignments_Submission_Quiz" UserDataComponentName="Assignments_Submission_QuizTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="FillQuizSubmissions" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetQuizSubmissions" GeneratorSourceName="FillQuizSubmissions" GetMethodModifier="Public" GetMethodName="GetQuizSubmissions" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetQuizSubmissions" UserSourceName="FillQuizSubmissions">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     Assignments_Submission_Quiz.QuizSubmissionID, Assignments_Submission_Quiz.AssignmentID, Assignments_Submission_Quiz.UserID, 
                      Assignments_Submission_Quiz.CourseID, Assignments_Submission_Quiz.SectionNumber, Assignments_Submission_Quiz.StandardID, 
                      Assignments_Submission_Quiz.Attempts, Assignments_Submission_Quiz.StudentAnswers, 
                      Assignments_Submission_Quiz.GradePercentage, Assignments_Submission_Quiz.SubmittedDateTime, 
                      Users.Username, Users.FirstName, Users.LastName, Users.StudentIDNumber, Users.Year, Assignments_Submission_Quiz.StartedDateTime
FROM         Assignments_Submission_Quiz INNER JOIN
                      Users ON Assignments_Submission_Quiz.UserID = Users.UserID</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="QuizSubmissionID" DataSetColumn="QuizSubmissionID" />
              <Mapping SourceColumn="AssignmentID" DataSetColumn="AssignmentID" />
              <Mapping SourceColumn="UserID" DataSetColumn="UserID" />
              <Mapping SourceColumn="Attempts" DataSetColumn="Attempts" />
              <Mapping SourceColumn="StudentAnswers" DataSetColumn="StudentAnswers" />
              <Mapping SourceColumn="GradePercentage" DataSetColumn="GradePercentage" />
              <Mapping SourceColumn="SubmittedDateTime" DataSetColumn="SubmittedDateTime" />
              <Mapping SourceColumn="CourseID" DataSetColumn="CourseID" />
              <Mapping SourceColumn="SectionNumber" DataSetColumn="SectionNumber" />
              <Mapping SourceColumn="StandardID" DataSetColumn="StandardID" />
              <Mapping SourceColumn="Username" DataSetColumn="Username" />
              <Mapping SourceColumn="FirstName" DataSetColumn="FirstName" />
              <Mapping SourceColumn="LastName" DataSetColumn="LastName" />
              <Mapping SourceColumn="StudentIDNumber" DataSetColumn="StudentIDNumber" />
              <Mapping SourceColumn="Year" DataSetColumn="Year" />
              <Mapping SourceColumn="StartedDateTime" DataSetColumn="StartedDateTime" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy3" GeneratorSourceName="DeleteQuizSubmissionByAssignmentIdAndUserIdAndCourseIdAndSectionNumber" Modifier="Public" Name="DeleteQuizSubmissionByAssignmentIdAndUserIdAndCourseIdAndSectionNumber" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="DeleteQuizSubmissionByAssignmentIdAndUserIdAndCourseIdAndSectionNumber">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>DELETE FROM Assignments_Submission_Quiz
WHERE     (AssignmentID = @AssignmentID) AND (UserID = @UserID) AND (CourseID = @CourseID) AND (SectionNumber = @SectionNumber)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="AssignmentID" ColumnName="AssignmentID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\DESKTOP\ILE RC1\APP_DATA\ILE.MDF].dbo.Assignments_Submission_Quiz" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@AssignmentID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="AssignmentID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="UserID" ColumnName="UserID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\DESKTOP\ILE RC1\APP_DATA\ILE.MDF].dbo.Assignments_Submission_Quiz" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@UserID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="CourseID" ColumnName="CourseID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\DESKTOP\ILE RC1\APP_DATA\ILE.MDF].dbo.Assignments_Submission_Quiz" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@CourseID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="CourseID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="SectionNumber" ColumnName="SectionNumber" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\DESKTOP\ILE RC1\APP_DATA\ILE.MDF].dbo.Assignments_Submission_Quiz" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@SectionNumber" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="SectionNumber" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
              </DbSource>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="DeleteQuizSubmissionByQuizSubmissionID" Modifier="Public" Name="DeleteQuizSubmissionByQuizSubmissionID" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="DeleteQuizSubmissionByQuizSubmissionID">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>DELETE FROM Assignments_Submission_Quiz
WHERE     (QuizSubmissionID = @QuizSubmissionID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="QuizSubmissionID" ColumnName="QuizSubmissionID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\DESKTOP\ILE RC1\APP_DATA\ILE.MDF].dbo.Assignments_Submission_Quiz" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@QuizSubmissionID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="QuizSubmissionID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
              </DbSource>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="FillBy" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy6" GeneratorSourceName="FillBy" GetMethodModifier="Public" GetMethodName="GetDataBy6" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy6" UserSourceName="FillBy">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     Assignments_Submission_Quiz.QuizSubmissionID, Assignments_Submission_Quiz.AssignmentID, Assignments_Submission_Quiz.UserID, 
                      Assignments_Submission_Quiz.CourseID, Assignments_Submission_Quiz.SectionNumber, Assignments_Submission_Quiz.StandardID, 
                      Assignments_Submission_Quiz.Attempts, Assignments_Submission_Quiz.StudentAnswers, Assignments_Submission_Quiz.GradePercentage, 
                      Assignments_Submission_Quiz.SubmittedDateTime, Users.Username, Users.FirstName, Users.LastName, Users.StudentIDNumber, Users.Year, 
                      Assignments_Submission_Quiz.StartedDateTime
FROM         Assignments_Submission_Quiz INNER JOIN
                      Users ON Assignments_Submission_Quiz.UserID = Users.UserID
WHERE     (Assignments_Submission_Quiz.QuizSubmissionID &gt; 900)</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="FillQuizSubmission" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetQuizSubmission" GeneratorSourceName="FillQuizSubmission" GetMethodModifier="Public" GetMethodName="GetQuizSubmission" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetQuizSubmission" UserSourceName="FillQuizSubmission">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     Assignments_Submission_Quiz.QuizSubmissionID, Assignments_Submission_Quiz.AssignmentID, Assignments_Submission_Quiz.UserID, 
                      Assignments_Submission_Quiz.CourseID, Assignments_Submission_Quiz.SectionNumber, Assignments_Submission_Quiz.StandardID, 
                      Assignments_Submission_Quiz.Attempts, Assignments_Submission_Quiz.StudentAnswers, Assignments_Submission_Quiz.GradePercentage, 
                      Assignments_Submission_Quiz.SubmittedDateTime, Users.Username, Users.FirstName, Users.LastName, Users.StudentIDNumber, Users.Year, 
                      Assignments_Submission_Quiz.StartedDateTime
FROM         Assignments_Submission_Quiz INNER JOIN
                      Users ON Assignments_Submission_Quiz.UserID = Users.UserID
WHERE     (Assignments_Submission_Quiz.QuizSubmissionID = @QuizSubmissionID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="QuizSubmissionID" ColumnName="QuizSubmissionID" DataSourceName="[E:\WORKSPACE\ILE RC1\APP_DATA\ILE.MDF].dbo.Assignments_Submission_Quiz" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@QuizSubmissionID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="QuizSubmissionID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="FillQuizSubmissionsByAssignmentIdAndCourseIdAndSectionNumber" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetQuizSubmissionsByAssignmentIdAndCourseIdAndSectionNumber" GeneratorSourceName="FillQuizSubmissionsByAssignmentIdAndCourseIdAndSectionNumber" GetMethodModifier="Public" GetMethodName="GetQuizSubmissionsByAssignmentIdAndCourseIdAndSectionNumber" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetQuizSubmissionsByAssignmentIdAndCourseIdAndSectionNumber" UserSourceName="FillQuizSubmissionsByAssignmentIdAndCourseIdAndSectionNumber">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     Assignments_Submission_Quiz.AssignmentID, Assignments_Submission_Quiz.Attempts, Assignments_Submission_Quiz.CourseID, 
                      Assignments_Submission_Quiz.GradePercentage, Assignments_Submission_Quiz.QuizSubmissionID, 
                      Assignments_Submission_Quiz.SectionNumber, Assignments_Submission_Quiz.StandardID, Assignments_Submission_Quiz.StudentAnswers, 
                      Assignments_Submission_Quiz.SubmittedDateTime, Assignments_Submission_Quiz.UserID, Users.Username, Users.FirstName, Users.LastName, 
                      Users.StudentIDNumber, Users.Year, Assignments_Submission_Quiz.StartedDateTime
FROM         Assignments_Submission_Quiz INNER JOIN
                      Users ON Assignments_Submission_Quiz.UserID = Users.UserID
WHERE     (Assignments_Submission_Quiz.AssignmentID = @AssignmentID) AND (Assignments_Submission_Quiz.CourseID = @CourseID) AND 
                      (Assignments_Submission_Quiz.SectionNumber = @SectionNumber)
ORDER BY Assignments_Submission_Quiz.UserID, Assignments_Submission_Quiz.Attempts</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="AssignmentID" ColumnName="AssignmentID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\DESKTOP\ILE RC1\APP_DATA\ILE.MDF].dbo.Assignments_Submission_Quiz" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@AssignmentID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="AssignmentID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="CourseID" ColumnName="CourseID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\DESKTOP\ILE RC1\APP_DATA\ILE.MDF].dbo.Assignments_Submission_Quiz" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@CourseID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="CourseID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="SectionNumber" ColumnName="SectionNumber" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\DESKTOP\ILE RC1\APP_DATA\ILE.MDF].dbo.Assignments_Submission_Quiz" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@SectionNumber" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="SectionNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="FillQuizSubmissionsByAssignmentIdAndCourseIdAndSectionNumberAndUserID" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetQuizSubmissionsByAssignmentIdAndCourseIdAndSectionNumberAndUserID" GeneratorSourceName="FillQuizSubmissionsByAssignmentIdAndCourseIdAndSectionNumberAndUserID" GetMethodModifier="Public" GetMethodName="GetQuizSubmissionsByAssignmentIdAndCourseIdAndSectionNumberAndUserID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetQuizSubmissionsByAssignmentIdAndCourseIdAndSectionNumberAndUserID" UserSourceName="FillQuizSubmissionsByAssignmentIdAndCourseIdAndSectionNumberAndUserID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     Assignments_Submission_Quiz.AssignmentID, Assignments_Submission_Quiz.Attempts, Assignments_Submission_Quiz.CourseID, 
                      Assignments_Submission_Quiz.GradePercentage, Assignments_Submission_Quiz.QuizSubmissionID, 
                      Assignments_Submission_Quiz.SectionNumber, Assignments_Submission_Quiz.StandardID, Assignments_Submission_Quiz.StudentAnswers, 
                      Assignments_Submission_Quiz.SubmittedDateTime, Assignments_Submission_Quiz.UserID, Users.Username, Users.FirstName, Users.LastName, 
                      Users.StudentIDNumber, Users.Year, Assignments_Submission_Quiz.StartedDateTime
FROM         Assignments_Submission_Quiz INNER JOIN
                      Users ON Assignments_Submission_Quiz.UserID = Users.UserID
WHERE     (Assignments_Submission_Quiz.AssignmentID = @AssignmentID) AND (Assignments_Submission_Quiz.CourseID = @CourseID) AND 
                      (Assignments_Submission_Quiz.SectionNumber = @SectionNumber) AND (Assignments_Submission_Quiz.UserID = @UserID)
ORDER BY Assignments_Submission_Quiz.Attempts</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="AssignmentID" ColumnName="AssignmentID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\DESKTOP\ILE RC1\APP_DATA\ILE.MDF].dbo.Assignments_Submission_Quiz" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@AssignmentID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="AssignmentID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="CourseID" ColumnName="CourseID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\DESKTOP\ILE RC1\APP_DATA\ILE.MDF].dbo.Assignments_Submission_Quiz" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@CourseID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="CourseID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="SectionNumber" ColumnName="SectionNumber" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\DESKTOP\ILE RC1\APP_DATA\ILE.MDF].dbo.Assignments_Submission_Quiz" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@SectionNumber" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="SectionNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="UserID" ColumnName="UserID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\DESKTOP\ILE RC1\APP_DATA\ILE.MDF].dbo.Assignments_Submission_Quiz" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@UserID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="FillQuizSubmissionsByAssignmentIdAndUserId" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetQuizSubmissionsByAssignmentIdAndUserId" GeneratorSourceName="FillQuizSubmissionsByAssignmentIdAndUserId" GetMethodModifier="Public" GetMethodName="GetQuizSubmissionsByAssignmentIdAndUserId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetQuizSubmissionsByAssignmentIdAndUserId" UserSourceName="FillQuizSubmissionsByAssignmentIdAndUserId">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     Assignments_Submission_Quiz.AssignmentID, Assignments_Submission_Quiz.Attempts, Assignments_Submission_Quiz.CourseID, 
                      Assignments_Submission_Quiz.GradePercentage, Assignments_Submission_Quiz.QuizSubmissionID, 
                      Assignments_Submission_Quiz.SectionNumber, Assignments_Submission_Quiz.StandardID, Assignments_Submission_Quiz.StudentAnswers, 
                      Assignments_Submission_Quiz.SubmittedDateTime, Assignments_Submission_Quiz.UserID, Users.Username, Users.FirstName, Users.LastName, 
                      Users.StudentIDNumber, Users.Year, Assignments_Submission_Quiz.StartedDateTime
FROM         Assignments_Submission_Quiz INNER JOIN
                      Users ON Assignments_Submission_Quiz.UserID = Users.UserID
WHERE     (Assignments_Submission_Quiz.AssignmentID = @AssignmentID) AND (Assignments_Submission_Quiz.UserID = @UserID)
ORDER BY Assignments_Submission_Quiz.Attempts DESC</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="AssignmentID" ColumnName="AssignmentID" DataSourceName="[E:\WORKSPACE\ILE RC1\APP_DATA\ILE.MDF].dbo.Assignments_Submission_Quiz" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@AssignmentID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="AssignmentID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="UserID" ColumnName="UserID" DataSourceName="[E:\WORKSPACE\ILE RC1\APP_DATA\ILE.MDF].dbo.Assignments_Submission_Quiz" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@UserID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="InsertQuizSubmission" Modifier="Public" Name="InsertQuizSubmission" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="InsertQuizSubmission">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>INSERT INTO Assignments_Submission_Quiz
                      (AssignmentID, UserID, CourseID, SectionNumber, StandardID, Attempts, StudentAnswers, GradePercentage, StartedDateTime, SubmittedDateTime)
VALUES     (@AssignmentID,@UserID,@CourseID,@SectionNumber,@StandardID,@Attempts,@StudentAnswers,@GradePercentage,@StartedDateTime,@SubmittedDateTime);      
SELECT SCOPE_IDENTITY()</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="AssignmentID" ColumnName="AssignmentID" DataSourceName="[E:\WORKSPACE\ILE RC1\APP_DATA\ILE.MDF].dbo.Assignments_Submission_Quiz" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@AssignmentID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="AssignmentID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="UserID" ColumnName="UserID" DataSourceName="[E:\WORKSPACE\ILE RC1\APP_DATA\ILE.MDF].dbo.Assignments_Submission_Quiz" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@UserID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="CourseID" ColumnName="CourseID" DataSourceName="[E:\WORKSPACE\ILE RC1\APP_DATA\ILE.MDF].dbo.Assignments_Submission_Quiz" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@CourseID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="CourseID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="SectionNumber" ColumnName="SectionNumber" DataSourceName="[E:\WORKSPACE\ILE RC1\APP_DATA\ILE.MDF].dbo.Assignments_Submission_Quiz" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@SectionNumber" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="SectionNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="StandardID" ColumnName="StandardID" DataSourceName="[E:\WORKSPACE\ILE RC1\APP_DATA\ILE.MDF].dbo.Assignments_Submission_Quiz" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@StandardID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="StandardID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Attempts" ColumnName="Attempts" DataSourceName="[E:\WORKSPACE\ILE RC1\APP_DATA\ILE.MDF].dbo.Assignments_Submission_Quiz" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Attempts" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Attempts" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="StudentAnswers" ColumnName="StudentAnswers" DataSourceName="[E:\WORKSPACE\ILE RC1\APP_DATA\ILE.MDF].dbo.Assignments_Submission_Quiz" DataTypeServer="xml" DbType="Object" Direction="Input" ParameterName="@StudentAnswers" Precision="0" ProviderType="Xml" Scale="0" Size="2147483647" SourceColumn="StudentAnswers" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="GradePercentage" ColumnName="GradePercentage" DataSourceName="[E:\WORKSPACE\ILE RC1\APP_DATA\ILE.MDF].dbo.Assignments_Submission_Quiz" DataTypeServer="decimal(5, 2)" DbType="Decimal" Direction="Input" ParameterName="@GradePercentage" Precision="5" ProviderType="Decimal" Scale="2" Size="5" SourceColumn="GradePercentage" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="StartedDateTime" ColumnName="StartedDateTime" DataSourceName="[E:\WORKSPACE\ILE RC1\APP_DATA\ILE.MDF].dbo.Assignments_Submission_Quiz" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@StartedDateTime" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="StartedDateTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="SubmittedDateTime" ColumnName="SubmittedDateTime" DataSourceName="[E:\WORKSPACE\ILE RC1\APP_DATA\ILE.MDF].dbo.Assignments_Submission_Quiz" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@SubmittedDateTime" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="SubmittedDateTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
              </DbSource>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="MoveQuizSubmissionToOtherCourseSection" Modifier="Public" Name="MoveQuizSubmissionToOtherCourseSection" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy3" UserSourceName="MoveQuizSubmissionToOtherCourseSection">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE    Assignments_Submission_Quiz
SET              CourseID = @CourseID, SectionNumber = @SectionNumber
WHERE     (QuizSubmissionID = @QuizSubmissionID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="CourseID" ColumnName="CourseID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\DESKTOP\ILE RC1\APP_DATA\ILE.MDF].dbo.Assignments_Submission_Quiz" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@CourseID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="CourseID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="SectionNumber" ColumnName="SectionNumber" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\DESKTOP\ILE RC1\APP_DATA\ILE.MDF].dbo.Assignments_Submission_Quiz" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@SectionNumber" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="SectionNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="QuizSubmissionID" ColumnName="QuizSubmissionID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\DESKTOP\ILE RC1\APP_DATA\ILE.MDF].dbo.Assignments_Submission_Quiz" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@QuizSubmissionID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="QuizSubmissionID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="UpdateQuizSubmission" Modifier="Public" Name="UpdateQuizSubmission" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy4" UserSourceName="UpdateQuizSubmission">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE    Assignments_Submission_Quiz
SET              StudentAnswers = @StudentAnswers, GradePercentage = @GradePercentage, SubmittedDateTime = @SubmittedDateTime
WHERE     (QuizSubmissionID = @Original_QuizSubmissionID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="StudentAnswers" ColumnName="StudentAnswers" DataSourceName="[E:\WORKSPACE\ILE RC1\APP_DATA\ILE.MDF].dbo.Assignments_Submission_Quiz" DataTypeServer="xml" DbType="Object" Direction="Input" ParameterName="@StudentAnswers" Precision="0" ProviderType="Xml" Scale="0" Size="2147483647" SourceColumn="StudentAnswers" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="GradePercentage" ColumnName="GradePercentage" DataSourceName="[E:\WORKSPACE\ILE RC1\APP_DATA\ILE.MDF].dbo.Assignments_Submission_Quiz" DataTypeServer="decimal(5, 2)" DbType="Decimal" Direction="Input" ParameterName="@GradePercentage" Precision="5" ProviderType="Decimal" Scale="2" Size="5" SourceColumn="GradePercentage" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="SubmittedDateTime" ColumnName="SubmittedDateTime" DataSourceName="[E:\WORKSPACE\ILE RC1\APP_DATA\ILE.MDF].dbo.Assignments_Submission_Quiz" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@SubmittedDateTime" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="SubmittedDateTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Original_QuizSubmissionID" ColumnName="QuizSubmissionID" DataSourceName="[E:\WORKSPACE\ILE RC1\APP_DATA\ILE.MDF].dbo.Assignments_Submission_Quiz" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_QuizSubmissionID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="QuizSubmissionID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy4" GeneratorSourceName="UpdateQuizSubmissionSectionNumberByQuizSubmissionID" Modifier="Public" Name="UpdateQuizSubmissionSectionNumberByQuizSubmissionID" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy5" UserSourceName="UpdateQuizSubmissionSectionNumberByQuizSubmissionID">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE    Assignments_Submission_Quiz
SET              SectionNumber = @SectionNumber
WHERE     (QuizSubmissionID = @Original_QuizSubmissionID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="SectionNumber" ColumnName="SectionNumber" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\DESKTOP\ILE RC1\APP_DATA\ILE.MDF].dbo.Assignments_Submission_Quiz" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@SectionNumber" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="SectionNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Original_QuizSubmissionID" ColumnName="QuizSubmissionID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\DESKTOP\ILE RC1\APP_DATA\ILE.MDF].dbo.Assignments_Submission_Quiz" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_QuizSubmissionID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="QuizSubmissionID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Assignments_Submission_EssayTableAdapter" GeneratorDataComponentClassName="Assignments_Submission_EssayTableAdapter" Name="Assignments_Submission_Essay" UserDataComponentName="Assignments_Submission_EssayTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="FillEssaySubmissions" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetEssaySubmissions" GeneratorSourceName="FillEssaySubmissions" GetMethodModifier="Public" GetMethodName="GetEssaySubmissions" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetEssaySubmissions" UserSourceName="FillEssaySubmissions">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     Assignments_Submission_Essay.EssaySubmissionID, Assignments_Submission_Essay.AssignmentID, Assignments_Submission_Essay.UserID, 
                      Assignments_Submission_Essay.CourseID, Assignments_Submission_Essay.SectionNumber, Assignments_Submission_Essay.StandardID, 
                      Assignments_Submission_Essay.StudentAnswer, Assignments_Submission_Essay.IsFinal, Assignments_Submission_Essay.TimeStamp, 
                      Assignments_Submission_Essay.SubmittedDateTime, Assignments_Submission_Essay.Grade, Users.Username, Users.FirstName, Users.LastName, 
                      Users.StudentIDNumber, Users.Year
FROM         Assignments_Submission_Essay INNER JOIN
                      Users ON Assignments_Submission_Essay.UserID = Users.UserID</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="EssaySubmissionID" DataSetColumn="EssaySubmissionID" />
              <Mapping SourceColumn="AssignmentID" DataSetColumn="AssignmentID" />
              <Mapping SourceColumn="UserID" DataSetColumn="UserID" />
              <Mapping SourceColumn="StudentAnswer" DataSetColumn="StudentAnswer" />
              <Mapping SourceColumn="IsFinal" DataSetColumn="IsFinal" />
              <Mapping SourceColumn="GradePercentage" DataSetColumn="Grade" />
              <Mapping SourceColumn="TimeStamp" DataSetColumn="TimeStamp" />
              <Mapping SourceColumn="SubmittedDateTime" DataSetColumn="SubmittedDateTime" />
              <Mapping SourceColumn="CourseID" DataSetColumn="CourseID" />
              <Mapping SourceColumn="SectionNumber" DataSetColumn="SectionNumber" />
              <Mapping SourceColumn="StandardID" DataSetColumn="StandardID" />
              <Mapping SourceColumn="Grade" DataSetColumn="Grade" />
              <Mapping SourceColumn="Username" DataSetColumn="Username" />
              <Mapping SourceColumn="FirstName" DataSetColumn="FirstName" />
              <Mapping SourceColumn="LastName" DataSetColumn="LastName" />
              <Mapping SourceColumn="StudentIDNumber" DataSetColumn="StudentIDNumber" />
              <Mapping SourceColumn="Year" DataSetColumn="Year" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="DeleteEssaySubmissionByEssaySubmissionID" Modifier="Public" Name="DeleteEssaySubmissionByEssaySubmissionID" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="DeleteEssaySubmissionByEssaySubmissionID">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>DELETE FROM Assignments_Submission_Essay
WHERE     (EssaySubmissionID = @EssaySubmissionID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="EssaySubmissionID" ColumnName="EssaySubmissionID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\DESKTOP\ILE RC1\APP_DATA\ILE.MDF].dbo.Assignments_Submission_Essay" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@EssaySubmissionID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="EssaySubmissionID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
              </DbSource>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="FillEssaySubmission" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetEssaySubmission" GeneratorSourceName="FillEssaySubmission" GetMethodModifier="Public" GetMethodName="GetEssaySubmission" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetEssaySubmission" UserSourceName="FillEssaySubmission">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     Assignments_Submission_Essay.EssaySubmissionID, Assignments_Submission_Essay.AssignmentID, Assignments_Submission_Essay.UserID, 
                      Assignments_Submission_Essay.CourseID, Assignments_Submission_Essay.SectionNumber, Assignments_Submission_Essay.StandardID, 
                      Assignments_Submission_Essay.StudentAnswer, Assignments_Submission_Essay.IsFinal, Assignments_Submission_Essay.TimeStamp, 
                      Assignments_Submission_Essay.SubmittedDateTime, Assignments_Submission_Essay.Grade, Users.Username, Users.FirstName, Users.LastName, 
                      Users.StudentIDNumber, Users.Year
FROM         Assignments_Submission_Essay INNER JOIN
                      Users ON Assignments_Submission_Essay.UserID = Users.UserID
WHERE     (Assignments_Submission_Essay.EssaySubmissionID = @EssaySubmissionID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="EssaySubmissionID" ColumnName="EssaySubmissionID" DataSourceName="[E:\WORKSPACE\ILE RC1\APP_DATA\ILE.MDF].dbo.Assignments_Submission_Essay" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@EssaySubmissionID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="EssaySubmissionID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="FillEssaySubmissionByAssignmentId" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetEssaySubmissionByAssignmentId" GeneratorSourceName="FillEssaySubmissionByAssignmentId" GetMethodModifier="Public" GetMethodName="GetEssaySubmissionByAssignmentId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetEssaySubmissionByAssignmentId" UserSourceName="FillEssaySubmissionByAssignmentId">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     Assignments_Submission_Essay.AssignmentID, Assignments_Submission_Essay.CourseID, Assignments_Submission_Essay.EssaySubmissionID, 
                      Assignments_Submission_Essay.Grade, Assignments_Submission_Essay.IsFinal, Assignments_Submission_Essay.SectionNumber, 
                      Assignments_Submission_Essay.StandardID, Assignments_Submission_Essay.StudentAnswer, Assignments_Submission_Essay.SubmittedDateTime,
                       Assignments_Submission_Essay.TimeStamp, Assignments_Submission_Essay.UserID, Users.Username, Users.FirstName, Users.LastName, 
                      Users.StudentIDNumber, Users.Year
FROM         Assignments_Submission_Essay INNER JOIN
                      Users ON Assignments_Submission_Essay.UserID = Users.UserID
WHERE     (Assignments_Submission_Essay.AssignmentID = @AssignmentID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="AssignmentID" ColumnName="AssignmentID" DataSourceName="[E:\WORKSPACE\ILE RC1\APP_DATA\ILE.MDF].dbo.Assignments_Submission_Essay" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@AssignmentID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="AssignmentID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="FillEssaySubmissionByAssignmentIdAndUserId" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetEssaySubmissionByAssignmentIdAndUserId" GeneratorSourceName="FillEssaySubmissionByAssignmentIdAndUserId" GetMethodModifier="Public" GetMethodName="GetEssaySubmissionByAssignmentIdAndUserId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetEssaySubmissionByAssignmentIdAndUserId" UserSourceName="FillEssaySubmissionByAssignmentIdAndUserId">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     Assignments_Submission_Essay.AssignmentID, Assignments_Submission_Essay.CourseID, Assignments_Submission_Essay.EssaySubmissionID, 
                      Assignments_Submission_Essay.Grade, Assignments_Submission_Essay.IsFinal, Assignments_Submission_Essay.SectionNumber, 
                      Assignments_Submission_Essay.StandardID, Assignments_Submission_Essay.StudentAnswer, Assignments_Submission_Essay.SubmittedDateTime,
                       Assignments_Submission_Essay.TimeStamp, Assignments_Submission_Essay.UserID, Users.Username, Users.FirstName, Users.LastName, 
                      Users.StudentIDNumber, Users.Year
FROM         Assignments_Submission_Essay INNER JOIN
                      Users ON Assignments_Submission_Essay.UserID = Users.UserID
WHERE     (Assignments_Submission_Essay.AssignmentID = @AssignmentID) AND (Assignments_Submission_Essay.UserID = @UserID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="AssignmentID" ColumnName="AssignmentID" DataSourceName="[E:\WORKSPACE\ILE RC1\APP_DATA\ILE.MDF].dbo.Assignments_Submission_Essay" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@AssignmentID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="AssignmentID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="UserID" ColumnName="UserID" DataSourceName="[E:\WORKSPACE\ILE RC1\APP_DATA\ILE.MDF].dbo.Assignments_Submission_Essay" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@UserID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="FillEssaySubmissionsByAssignmentIdAndCourseIdAndSectionNumber" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetEssaySubmissionsByAssignmentIdAndCourseIdAndSectionNumber" GeneratorSourceName="FillEssaySubmissionsByAssignmentIdAndCourseIdAndSectionNumber" GetMethodModifier="Public" GetMethodName="GetEssaySubmissionsByAssignmentIdAndCourseIdAndSectionNumber" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetEssaySubmissionsByAssignmentIdAndCourseIdAndSectionNumber" UserSourceName="FillEssaySubmissionsByAssignmentIdAndCourseIdAndSectionNumber">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     Assignments_Submission_Essay.EssaySubmissionID, Assignments_Submission_Essay.AssignmentID, Assignments_Submission_Essay.UserID, 
                      Assignments_Submission_Essay.CourseID, Assignments_Submission_Essay.SectionNumber, Assignments_Submission_Essay.StandardID, 
                      Assignments_Submission_Essay.StudentAnswer, Assignments_Submission_Essay.IsFinal, Assignments_Submission_Essay.TimeStamp, 
                      Assignments_Submission_Essay.SubmittedDateTime, Assignments_Submission_Essay.Grade, Users.Username, Users.FirstName, Users.LastName, 
                      Users.StudentIDNumber, Users.Year
FROM         Assignments_Submission_Essay INNER JOIN
                      Users ON Assignments_Submission_Essay.UserID = Users.UserID
WHERE     (Assignments_Submission_Essay.AssignmentID = @AssignmentID) AND (Assignments_Submission_Essay.CourseID = @CourseID) AND 
                      (Assignments_Submission_Essay.SectionNumber = @SectionNumber) AND (Assignments_Submission_Essay.IsFinal = 1)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="AssignmentID" ColumnName="AssignmentID" DataSourceName="[ILE3.0dev].dbo.Assignments_Submission_Essay" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@AssignmentID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="AssignmentID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="CourseID" ColumnName="CourseID" DataSourceName="[ILE3.0dev].dbo.Assignments_Submission_Essay" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@CourseID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="CourseID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="SectionNumber" ColumnName="SectionNumber" DataSourceName="[ILE3.0dev].dbo.Assignments_Submission_Essay" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@SectionNumber" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="SectionNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="InsertEssaySubmission" Modifier="Public" Name="InsertEssaySubmission" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="InsertEssaySubmission">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>INSERT INTO Assignments_Submission_Essay
                      (AssignmentID, UserID, CourseID, SectionNumber, StandardID, StudentAnswer, IsFinal, Grade, TimeStamp, SubmittedDateTime)
VALUES     (@AssignmentID,@UserID,@CourseID,@SectionNumber,@StandardID,@StudentAnswer,@IsFinal,@Grade,@TimeStamp,@SubmittedDateTime);  
SELECT SCOPE_IDENTITY()</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="AssignmentID" ColumnName="AssignmentID" DataSourceName="[ILE3.0dev].dbo.Assignments_Submission_Essay" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@AssignmentID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="AssignmentID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="UserID" ColumnName="UserID" DataSourceName="[ILE3.0dev].dbo.Assignments_Submission_Essay" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@UserID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="CourseID" ColumnName="CourseID" DataSourceName="[ILE3.0dev].dbo.Assignments_Submission_Essay" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@CourseID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="CourseID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="SectionNumber" ColumnName="SectionNumber" DataSourceName="[ILE3.0dev].dbo.Assignments_Submission_Essay" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@SectionNumber" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="SectionNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="StandardID" ColumnName="StandardID" DataSourceName="[ILE3.0dev].dbo.Assignments_Submission_Essay" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@StandardID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="StandardID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="StudentAnswer" ColumnName="StudentAnswer" DataSourceName="[ILE3.0dev].dbo.Assignments_Submission_Essay" DataTypeServer="text" DbType="AnsiString" Direction="Input" ParameterName="@StudentAnswer" Precision="0" ProviderType="Text" Scale="0" Size="2147483647" SourceColumn="StudentAnswer" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="IsFinal" ColumnName="IsFinal" DataSourceName="[ILE3.0dev].dbo.Assignments_Submission_Essay" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@IsFinal" Precision="0" ProviderType="Bit" Scale="0" Size="1" SourceColumn="IsFinal" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Grade" ColumnName="Grade" DataSourceName="[ILE3.0dev].dbo.Assignments_Submission_Essay" DataTypeServer="varchar(10)" DbType="AnsiString" Direction="Input" ParameterName="@Grade" Precision="0" ProviderType="VarChar" Scale="0" Size="10" SourceColumn="Grade" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="TimeStamp" ColumnName="TimeStamp" DataSourceName="[ILE3.0dev].dbo.Assignments_Submission_Essay" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@TimeStamp" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="TimeStamp" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="SubmittedDateTime" ColumnName="SubmittedDateTime" DataSourceName="[ILE3.0dev].dbo.Assignments_Submission_Essay" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@SubmittedDateTime" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="SubmittedDateTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
              </DbSource>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="MoveEssaySubmissionToOtherCourseSection" Modifier="Public" Name="MoveEssaySubmissionToOtherCourseSection" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="MoveEssaySubmissionToOtherCourseSection">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE    Assignments_Submission_Essay
SET              CourseID = @CourseID, SectionNumber = @SectionNumber
WHERE     (EssaySubmissionID = @EssaySubmissionID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="CourseID" ColumnName="CourseID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\DESKTOP\ILE RC1\APP_DATA\ILE.MDF].dbo.Assignments_Submission_Essay" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@CourseID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="CourseID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="SectionNumber" ColumnName="SectionNumber" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\DESKTOP\ILE RC1\APP_DATA\ILE.MDF].dbo.Assignments_Submission_Essay" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@SectionNumber" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="SectionNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="EssaySubmissionID" ColumnName="EssaySubmissionID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\DESKTOP\ILE RC1\APP_DATA\ILE.MDF].dbo.Assignments_Submission_Essay" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@EssaySubmissionID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="EssaySubmissionID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="UpdateEssaySubmission" Modifier="Public" Name="UpdateEssaySubmission" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy3" UserSourceName="UpdateEssaySubmission">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE [Assignments_Submission_Essay] SET [StudentAnswer] = @StudentAnswer, [IsFinal] = @IsFinal,  [SubmittedDateTime] = @SubmittedDateTime WHERE (([EssaySubmissionID] = @Original_EssaySubmissionID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="StudentAnswer" ColumnName="StudentAnswer" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\DESKTOP\ILE RC1\APP_DATA\ILE.MDF].dbo.Assignments_Submission_Essay" DataTypeServer="text" DbType="AnsiString" Direction="Input" ParameterName="@StudentAnswer" Precision="0" ProviderType="Text" Scale="0" Size="2147483647" SourceColumn="StudentAnswer" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="IsFinal" ColumnName="IsFinal" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\DESKTOP\ILE RC1\APP_DATA\ILE.MDF].dbo.Assignments_Submission_Essay" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@IsFinal" Precision="0" ProviderType="Bit" Scale="0" Size="1" SourceColumn="IsFinal" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="SubmittedDateTime" ColumnName="SubmittedDateTime" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\DESKTOP\ILE RC1\APP_DATA\ILE.MDF].dbo.Assignments_Submission_Essay" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@SubmittedDateTime" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="SubmittedDateTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Original_EssaySubmissionID" ColumnName="EssaySubmissionID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\DESKTOP\ILE RC1\APP_DATA\ILE.MDF].dbo.Assignments_Submission_Essay" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_EssaySubmissionID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="EssaySubmissionID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy2" GeneratorSourceName="UpdateEssaySubmissionGrade" Modifier="Public" Name="UpdateEssaySubmissionGrade" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy4" UserSourceName="UpdateEssaySubmissionGrade">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE    Assignments_Submission_Essay
SET              Grade = @Grade
WHERE     (EssaySubmissionID = @EssaySubmissionID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="Grade" ColumnName="Grade" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\DESKTOP\ILE RC1\APP_DATA\ILE.MDF].dbo.Assignments_Submission_Essay" DataTypeServer="varchar(10)" DbType="AnsiString" Direction="Input" ParameterName="@Grade" Precision="0" ProviderType="VarChar" Scale="0" Size="10" SourceColumn="Grade" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="EssaySubmissionID" ColumnName="EssaySubmissionID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\DESKTOP\ILE RC1\APP_DATA\ILE.MDF].dbo.Assignments_Submission_Essay" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@EssaySubmissionID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="EssaySubmissionID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy3" GeneratorSourceName="UpdateEssaySubmissionIsFinal" Modifier="Public" Name="UpdateEssaySubmissionIsFinal" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy5" UserSourceName="UpdateEssaySubmissionIsFinal">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE    Assignments_Submission_Essay
SET              IsFinal = @IsFinal
WHERE     (EssaySubmissionID = @Original_EssaySubmissionID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="IsFinal" ColumnName="IsFinal" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\DESKTOP\ILE RC1\APP_DATA\ILE.MDF].dbo.Assignments_Submission_Essay" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@IsFinal" Precision="0" ProviderType="Bit" Scale="0" Size="1" SourceColumn="IsFinal" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Original_EssaySubmissionID" ColumnName="EssaySubmissionID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\DESKTOP\ILE RC1\APP_DATA\ILE.MDF].dbo.Assignments_Submission_Essay" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_EssaySubmissionID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="EssaySubmissionID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="UpdateEssaySubmissionSectionNumberByEssaySubmissionID" Modifier="Public" Name="UpdateEssaySubmissionSectionNumberByEssaySubmissionID" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy6" UserSourceName="UpdateEssaySubmissionSectionNumberByEssaySubmissionID">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE    Assignments_Submission_Essay
SET              SectionNumber = @SectionNumber
WHERE     (EssaySubmissionID = @EssaySubmissionID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="SectionNumber" ColumnName="SectionNumber" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\DESKTOP\ILE RC1\APP_DATA\ILE.MDF].dbo.Assignments_Submission_Essay" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@SectionNumber" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="SectionNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="EssaySubmissionID" ColumnName="EssaySubmissionID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\DESKTOP\ILE RC1\APP_DATA\ILE.MDF].dbo.Assignments_Submission_Essay" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@EssaySubmissionID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="EssaySubmissionID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Assignments_Submission_Essay_CommentsTableAdapter" GeneratorDataComponentClassName="Assignments_Submission_Essay_CommentsTableAdapter" Name="Assignments_Submission_Essay_Comments" UserDataComponentName="Assignments_Submission_Essay_CommentsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectName="dbo.Assignments_Submission_Essay_Comments" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillEssaySubmissionComments" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetEssaySubmissionComments" GeneratorSourceName="FillEssaySubmissionComments" GetMethodModifier="Public" GetMethodName="GetEssaySubmissionComments" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetEssaySubmissionComments" UserSourceName="FillEssaySubmissionComments">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [Assignments_Submission_Essay_Comments] WHERE (([EssaySubmissionID] = @Original_EssaySubmissionID) AND ([InstructorUserID] = @Original_InstructorUserID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_EssaySubmissionID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EssaySubmissionID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_InstructorUserID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="InstructorUserID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [Assignments_Submission_Essay_Comments] ([EssaySubmissionID], [InstructorUserID], [Comment], [TimeStamp]) VALUES (@EssaySubmissionID, @InstructorUserID, @Comment, @TimeStamp)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@EssaySubmissionID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EssaySubmissionID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@InstructorUserID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="InstructorUserID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Comment" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="Comment" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@TimeStamp" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="TimeStamp" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     EssaySubmissionID, InstructorUserID, Comment, TimeStamp
FROM         Assignments_Submission_Essay_Comments</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [Assignments_Submission_Essay_Comments] SET [EssaySubmissionID] = @EssaySubmissionID, [InstructorUserID] = @InstructorUserID, [Comment] = @Comment, [TimeStamp] = @TimeStamp WHERE (([EssaySubmissionID] = @Original_EssaySubmissionID) AND ([InstructorUserID] = @Original_InstructorUserID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@EssaySubmissionID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EssaySubmissionID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@InstructorUserID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="InstructorUserID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Comment" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="Comment" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@TimeStamp" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="TimeStamp" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_EssaySubmissionID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EssaySubmissionID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_InstructorUserID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="InstructorUserID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="EssaySubmissionID" DataSetColumn="EssaySubmissionID" />
              <Mapping SourceColumn="InstructorUserID" DataSetColumn="InstructorUserID" />
              <Mapping SourceColumn="Comment" DataSetColumn="Comment" />
              <Mapping SourceColumn="TimeStamp" DataSetColumn="TimeStamp" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectName="dbo.Assignments_Submission_Essay_Comments" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillEssaySubmissionComment" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetEssaySubmissionComment" GeneratorSourceName="FillEssaySubmissionComment" GetMethodModifier="Public" GetMethodName="GetEssaySubmissionComment" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetEssaySubmissionComment" UserSourceName="FillEssaySubmissionComment">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     EssaySubmissionID, InstructorUserID, Comment, TimeStamp
FROM         Assignments_Submission_Essay_Comments
WHERE EssaySubmissionID = @EssaySubmissionID AND InstructorUserID = @UserID</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="EssaySubmissionID" ColumnName="EssaySubmissionID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\DESKTOP\ILE RC1\APP_DATA\ILE.MDF].dbo.Assignments_Submission_Essay_Comments" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@EssaySubmissionID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="EssaySubmissionID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="UserID" ColumnName="InstructorUserID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\DESKTOP\ILE RC1\APP_DATA\ILE.MDF].dbo.Assignments_Submission_Essay_Comments" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@UserID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="InstructorUserID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectName="dbo.Assignments_Submission_Essay_Comments" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillEssaySubmissionCommentsByEssaySubmission" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetEssaySubmissionCommentsByEssaySubmission" GeneratorSourceName="FillEssaySubmissionCommentsByEssaySubmission" GetMethodModifier="Public" GetMethodName="GetEssaySubmissionCommentsByEssaySubmission" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetEssaySubmissionCommentsByEssaySubmission" UserSourceName="FillEssaySubmissionCommentsByEssaySubmission">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     EssaySubmissionID, InstructorUserID, Comment, TimeStamp
FROM         Assignments_Submission_Essay_Comments
WHERE EssaySubmissionID = @EssaySubmissionID</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="EssaySubmissionID" ColumnName="EssaySubmissionID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\DESKTOP\ILE RC1\APP_DATA\ILE.MDF].dbo.Assignments_Submission_Essay_Comments" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@EssaySubmissionID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="EssaySubmissionID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy" GeneratorSourceName="IsDuplicated" Modifier="Public" Name="IsDuplicated" QueryType="Scalar" ScalarCallRetval="System.Int32, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="IsDuplicated">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     COUNT(*) AS Expr1
FROM         Assignments_Submission_Essay_Comments
WHERE     (EssaySubmissionID = @EssaySubmissionID) AND (InstructorUserID = @UserID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="EssaySubmissionID" ColumnName="EssaySubmissionID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\DESKTOP\ILE RC1\APP_DATA\ILE.MDF].dbo.Assignments_Submission_Essay_Comments" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@EssaySubmissionID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="EssaySubmissionID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="UserID" ColumnName="InstructorUserID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\DESKTOP\ILE RC1\APP_DATA\ILE.MDF].dbo.Assignments_Submission_Essay_Comments" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@UserID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="InstructorUserID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="Assignments" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="Assignments" msprop:Generator_DataSetName="Assignments">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Assignments" msprop:Generator_UserTableName="Assignments" msprop:Generator_RowDeletedName="AssignmentsRowDeleted" msprop:Generator_RowChangedName="AssignmentsRowChanged" msprop:Generator_RowClassName="AssignmentsRow" msprop:Generator_RowChangingName="AssignmentsRowChanging" msprop:Generator_RowEvArgName="AssignmentsRowChangeEvent" msprop:Generator_RowEvHandlerName="AssignmentsRowChangeEventHandler" msprop:Generator_TableClassName="AssignmentsDataTable" msprop:Generator_TableVarName="tableAssignments" msprop:Generator_RowDeletingName="AssignmentsRowDeleting" msprop:Generator_TablePropName="_Assignments">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="AssignmentID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="AssignmentID" msprop:Generator_ColumnVarNameInTable="columnAssignmentID" msprop:Generator_ColumnPropNameInRow="AssignmentID" msprop:Generator_ColumnPropNameInTable="AssignmentIDColumn" type="xs:int" />
              <xs:element name="AssignmentType" msprop:Generator_UserColumnName="AssignmentType" msprop:Generator_ColumnVarNameInTable="columnAssignmentType" msprop:Generator_ColumnPropNameInRow="AssignmentType" msprop:Generator_ColumnPropNameInTable="AssignmentTypeColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AssignmentTitle" msprop:Generator_UserColumnName="AssignmentTitle" msprop:Generator_ColumnVarNameInTable="columnAssignmentTitle" msprop:Generator_ColumnPropNameInRow="AssignmentTitle" msprop:Generator_ColumnPropNameInTable="AssignmentTitleColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Instruction" msprop:Generator_UserColumnName="Instruction" msprop:Generator_ColumnVarNameInTable="columnInstruction" msprop:Generator_ColumnPropNameInRow="Instruction" msprop:Generator_ColumnPropNameInTable="InstructionColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SendNotifyStart" msprop:Generator_UserColumnName="SendNotifyStart" msprop:Generator_ColumnVarNameInTable="columnSendNotifyStart" msprop:Generator_ColumnPropNameInRow="SendNotifyStart" msprop:Generator_ColumnPropNameInTable="SendNotifyStartColumn" type="xs:boolean" />
              <xs:element name="SendNotifyEnd" msprop:Generator_UserColumnName="SendNotifyEnd" msprop:Generator_ColumnVarNameInTable="columnSendNotifyEnd" msprop:Generator_ColumnPropNameInRow="SendNotifyEnd" msprop:Generator_ColumnPropNameInTable="SendNotifyEndColumn" type="xs:boolean" />
              <xs:element name="SendNotifyEndHours" msprop:Generator_UserColumnName="SendNotifyEndHours" msprop:Generator_ColumnVarNameInTable="columnSendNotifyEndHours" msprop:Generator_ColumnPropNameInRow="SendNotifyEndHours" msprop:Generator_ColumnPropNameInTable="SendNotifyEndHoursColumn" type="xs:int" />
              <xs:element name="SendResult" msprop:Generator_UserColumnName="SendResult" msprop:Generator_ColumnVarNameInTable="columnSendResult" msprop:Generator_ColumnPropNameInRow="SendResult" msprop:Generator_ColumnPropNameInTable="SendResultColumn" type="xs:boolean" />
              <xs:element name="TimeStamp" msprop:Generator_UserColumnName="TimeStamp" msprop:Generator_ColumnVarNameInTable="columnTimeStamp" msprop:Generator_ColumnPropNameInRow="TimeStamp" msprop:Generator_ColumnPropNameInTable="TimeStampColumn" type="xs:dateTime" />
              <xs:element name="StartDateTime" msprop:Generator_UserColumnName="StartDateTime" msprop:Generator_ColumnVarNameInTable="columnStartDateTime" msprop:Generator_ColumnPropNameInRow="StartDateTime" msprop:Generator_ColumnPropNameInTable="StartDateTimeColumn" type="xs:dateTime" />
              <xs:element name="EndDateTime" msprop:Generator_UserColumnName="EndDateTime" msprop:Generator_ColumnVarNameInTable="columnEndDateTime" msprop:Generator_ColumnPropNameInRow="EndDateTime" msprop:Generator_ColumnPropNameInTable="EndDateTimeColumn" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="QuizAssignments" msprop:Generator_UserTableName="QuizAssignments" msprop:Generator_RowDeletedName="QuizAssignmentsRowDeleted" msprop:Generator_RowChangedName="QuizAssignmentsRowChanged" msprop:Generator_RowClassName="QuizAssignmentsRow" msprop:Generator_RowChangingName="QuizAssignmentsRowChanging" msprop:Generator_RowEvArgName="QuizAssignmentsRowChangeEvent" msprop:Generator_RowEvHandlerName="QuizAssignmentsRowChangeEventHandler" msprop:Generator_TableClassName="QuizAssignmentsDataTable" msprop:Generator_TableVarName="tableQuizAssignments" msprop:Generator_RowDeletingName="QuizAssignmentsRowDeleting" msprop:Generator_TablePropName="QuizAssignments">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="AssignmentID" msprop:Generator_UserColumnName="AssignmentID" msprop:Generator_ColumnVarNameInTable="columnAssignmentID" msprop:Generator_ColumnPropNameInRow="AssignmentID" msprop:Generator_ColumnPropNameInTable="AssignmentIDColumn" type="xs:int" />
              <xs:element name="QuizAssignment" msprop:Generator_UserColumnName="QuizAssignment" msprop:Generator_ColumnVarNameInTable="columnQuizAssignment" msprop:Generator_ColumnPropNameInRow="QuizAssignment" msprop:Generator_ColumnPropNameInTable="QuizAssignmentColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MaximumAttempts" msprop:Generator_UserColumnName="MaximumAttempts" msprop:Generator_ColumnVarNameInTable="columnMaximumAttempts" msprop:Generator_ColumnPropNameInRow="MaximumAttempts" msprop:Generator_ColumnPropNameInTable="MaximumAttemptsColumn" type="xs:int" />
              <xs:element name="AssignmentType" msprop:Generator_UserColumnName="AssignmentType" msprop:Generator_ColumnVarNameInTable="columnAssignmentType" msprop:Generator_ColumnPropNameInRow="AssignmentType" msprop:Generator_ColumnPropNameInTable="AssignmentTypeColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AssignmentTitle" msprop:Generator_UserColumnName="AssignmentTitle" msprop:Generator_ColumnVarNameInTable="columnAssignmentTitle" msprop:Generator_ColumnPropNameInRow="AssignmentTitle" msprop:Generator_ColumnPropNameInTable="AssignmentTitleColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Instruction" msprop:Generator_UserColumnName="Instruction" msprop:Generator_ColumnVarNameInTable="columnInstruction" msprop:Generator_ColumnPropNameInRow="Instruction" msprop:Generator_ColumnPropNameInTable="InstructionColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SendNotifyStart" msprop:Generator_UserColumnName="SendNotifyStart" msprop:Generator_ColumnVarNameInTable="columnSendNotifyStart" msprop:Generator_ColumnPropNameInRow="SendNotifyStart" msprop:Generator_ColumnPropNameInTable="SendNotifyStartColumn" type="xs:boolean" />
              <xs:element name="SendNotifyEnd" msprop:Generator_UserColumnName="SendNotifyEnd" msprop:Generator_ColumnVarNameInTable="columnSendNotifyEnd" msprop:Generator_ColumnPropNameInRow="SendNotifyEnd" msprop:Generator_ColumnPropNameInTable="SendNotifyEndColumn" type="xs:boolean" />
              <xs:element name="SendNotifyEndHours" msprop:Generator_UserColumnName="SendNotifyEndHours" msprop:Generator_ColumnVarNameInTable="columnSendNotifyEndHours" msprop:Generator_ColumnPropNameInRow="SendNotifyEndHours" msprop:Generator_ColumnPropNameInTable="SendNotifyEndHoursColumn" type="xs:int" />
              <xs:element name="SendResult" msprop:Generator_UserColumnName="SendResult" msprop:Generator_ColumnVarNameInTable="columnSendResult" msprop:Generator_ColumnPropNameInRow="SendResult" msprop:Generator_ColumnPropNameInTable="SendResultColumn" type="xs:boolean" />
              <xs:element name="TimeStamp" msprop:Generator_UserColumnName="TimeStamp" msprop:Generator_ColumnVarNameInTable="columnTimeStamp" msprop:Generator_ColumnPropNameInRow="TimeStamp" msprop:Generator_ColumnPropNameInTable="TimeStampColumn" type="xs:dateTime" />
              <xs:element name="StartDateTime" msprop:Generator_UserColumnName="StartDateTime" msprop:Generator_ColumnVarNameInTable="columnStartDateTime" msprop:Generator_ColumnPropNameInRow="StartDateTime" msprop:Generator_ColumnPropNameInTable="StartDateTimeColumn" type="xs:dateTime" />
              <xs:element name="EndDateTime" msprop:Generator_UserColumnName="EndDateTime" msprop:Generator_ColumnVarNameInTable="columnEndDateTime" msprop:Generator_ColumnPropNameInRow="EndDateTime" msprop:Generator_ColumnPropNameInTable="EndDateTimeColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="NumberOfQuestions" msprop:Generator_UserColumnName="NumberOfQuestions" msprop:Generator_ColumnPropNameInRow="NumberOfQuestions" msprop:Generator_ColumnVarNameInTable="columnNumberOfQuestions" msprop:Generator_ColumnPropNameInTable="NumberOfQuestionsColumn" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Relations" msprop:Generator_UserTableName="Relations" msprop:Generator_RowDeletedName="RelationsRowDeleted" msprop:Generator_RowChangedName="RelationsRowChanged" msprop:Generator_RowClassName="RelationsRow" msprop:Generator_RowChangingName="RelationsRowChanging" msprop:Generator_RowEvArgName="RelationsRowChangeEvent" msprop:Generator_RowEvHandlerName="RelationsRowChangeEventHandler" msprop:Generator_TableClassName="RelationsDataTable" msprop:Generator_TableVarName="tableRelations" msprop:Generator_RowDeletingName="RelationsRowDeleting" msprop:Generator_TablePropName="_Relations">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="AssignmentID" msprop:Generator_UserColumnName="AssignmentID" msprop:Generator_ColumnVarNameInTable="columnAssignmentID" msprop:Generator_ColumnPropNameInRow="AssignmentID" msprop:Generator_ColumnPropNameInTable="AssignmentIDColumn" type="xs:int" />
              <xs:element name="CourseID" msprop:Generator_UserColumnName="CourseID" msprop:Generator_ColumnVarNameInTable="columnCourseID" msprop:Generator_ColumnPropNameInRow="CourseID" msprop:Generator_ColumnPropNameInTable="CourseIDColumn" type="xs:int" />
              <xs:element name="SectionNumber" msprop:Generator_UserColumnName="SectionNumber" msprop:Generator_ColumnVarNameInTable="columnSectionNumber" msprop:Generator_ColumnPropNameInRow="SectionNumber" msprop:Generator_ColumnPropNameInTable="SectionNumberColumn" type="xs:int" />
              <xs:element name="StandardID" msprop:Generator_UserColumnName="StandardID" msprop:Generator_ColumnVarNameInTable="columnStandardID" msprop:Generator_ColumnPropNameInRow="StandardID" msprop:Generator_ColumnPropNameInTable="StandardIDColumn" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Assignments_Quiz" msprop:Generator_UserTableName="Assignments_Quiz" msprop:Generator_RowDeletedName="Assignments_QuizRowDeleted" msprop:Generator_RowChangedName="Assignments_QuizRowChanged" msprop:Generator_RowClassName="Assignments_QuizRow" msprop:Generator_RowChangingName="Assignments_QuizRowChanging" msprop:Generator_RowEvArgName="Assignments_QuizRowChangeEvent" msprop:Generator_RowEvHandlerName="Assignments_QuizRowChangeEventHandler" msprop:Generator_TableClassName="Assignments_QuizDataTable" msprop:Generator_TableVarName="tableAssignments_Quiz" msprop:Generator_RowDeletingName="Assignments_QuizRowDeleting" msprop:Generator_TablePropName="Assignments_Quiz">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="AssignmentID" msprop:Generator_UserColumnName="AssignmentID" msprop:Generator_ColumnVarNameInTable="columnAssignmentID" msprop:Generator_ColumnPropNameInRow="AssignmentID" msprop:Generator_ColumnPropNameInTable="AssignmentIDColumn" type="xs:int" />
              <xs:element name="QuizAssignment" msprop:Generator_UserColumnName="QuizAssignment" msprop:Generator_ColumnVarNameInTable="columnQuizAssignment" msprop:Generator_ColumnPropNameInRow="QuizAssignment" msprop:Generator_ColumnPropNameInTable="QuizAssignmentColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MaximumAttempts" msprop:Generator_UserColumnName="MaximumAttempts" msprop:Generator_ColumnVarNameInTable="columnMaximumAttempts" msprop:Generator_ColumnPropNameInRow="MaximumAttempts" msprop:Generator_ColumnPropNameInTable="MaximumAttemptsColumn" type="xs:int" />
              <xs:element name="NumberOfQuestions" msprop:Generator_UserColumnName="NumberOfQuestions" msprop:Generator_ColumnPropNameInRow="NumberOfQuestions" msprop:Generator_ColumnVarNameInTable="columnNumberOfQuestions" msprop:Generator_ColumnPropNameInTable="NumberOfQuestionsColumn" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Assignments_Submission_Quiz" msprop:Generator_UserTableName="Assignments_Submission_Quiz" msprop:Generator_RowDeletedName="Assignments_Submission_QuizRowDeleted" msprop:Generator_RowChangedName="Assignments_Submission_QuizRowChanged" msprop:Generator_RowClassName="Assignments_Submission_QuizRow" msprop:Generator_RowChangingName="Assignments_Submission_QuizRowChanging" msprop:Generator_RowEvArgName="Assignments_Submission_QuizRowChangeEvent" msprop:Generator_RowEvHandlerName="Assignments_Submission_QuizRowChangeEventHandler" msprop:Generator_TableClassName="Assignments_Submission_QuizDataTable" msprop:Generator_TableVarName="tableAssignments_Submission_Quiz" msprop:Generator_RowDeletingName="Assignments_Submission_QuizRowDeleting" msprop:Generator_TablePropName="Assignments_Submission_Quiz">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="QuizSubmissionID" msprop:Generator_UserColumnName="QuizSubmissionID" msprop:Generator_ColumnVarNameInTable="columnQuizSubmissionID" msprop:Generator_ColumnPropNameInRow="QuizSubmissionID" msprop:Generator_ColumnPropNameInTable="QuizSubmissionIDColumn" type="xs:int" />
              <xs:element name="AssignmentID" msprop:Generator_UserColumnName="AssignmentID" msprop:Generator_ColumnVarNameInTable="columnAssignmentID" msprop:Generator_ColumnPropNameInRow="AssignmentID" msprop:Generator_ColumnPropNameInTable="AssignmentIDColumn" type="xs:int" />
              <xs:element name="UserID" msprop:Generator_UserColumnName="UserID" msprop:Generator_ColumnVarNameInTable="columnUserID" msprop:Generator_ColumnPropNameInRow="UserID" msprop:Generator_ColumnPropNameInTable="UserIDColumn" type="xs:int" />
              <xs:element name="Attempts" msprop:Generator_UserColumnName="Attempts" msprop:Generator_ColumnVarNameInTable="columnAttempts" msprop:Generator_ColumnPropNameInRow="Attempts" msprop:Generator_ColumnPropNameInTable="AttemptsColumn" type="xs:int" />
              <xs:element name="StudentAnswers" msprop:Generator_UserColumnName="StudentAnswers" msprop:Generator_ColumnVarNameInTable="columnStudentAnswers" msprop:Generator_ColumnPropNameInRow="StudentAnswers" msprop:Generator_ColumnPropNameInTable="StudentAnswersColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="GradePercentage" msprop:Generator_UserColumnName="GradePercentage" msprop:Generator_ColumnVarNameInTable="columnGradePercentage" msprop:Generator_ColumnPropNameInRow="GradePercentage" msprop:Generator_ColumnPropNameInTable="GradePercentageColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="SubmittedDateTime" msprop:Generator_UserColumnName="SubmittedDateTime" msprop:Generator_ColumnVarNameInTable="columnSubmittedDateTime" msprop:Generator_ColumnPropNameInRow="SubmittedDateTime" msprop:Generator_ColumnPropNameInTable="SubmittedDateTimeColumn" type="xs:dateTime" />
              <xs:element name="CourseID" msprop:Generator_UserColumnName="CourseID" msprop:Generator_ColumnVarNameInTable="columnCourseID" msprop:Generator_ColumnPropNameInRow="CourseID" msprop:Generator_ColumnPropNameInTable="CourseIDColumn" type="xs:int" />
              <xs:element name="SectionNumber" msprop:Generator_UserColumnName="SectionNumber" msprop:Generator_ColumnVarNameInTable="columnSectionNumber" msprop:Generator_ColumnPropNameInRow="SectionNumber" msprop:Generator_ColumnPropNameInTable="SectionNumberColumn" type="xs:int" />
              <xs:element name="StandardID" msprop:Generator_UserColumnName="StandardID" msprop:Generator_ColumnVarNameInTable="columnStandardID" msprop:Generator_ColumnPropNameInRow="StandardID" msprop:Generator_ColumnPropNameInTable="StandardIDColumn" type="xs:int" />
              <xs:element name="Username" msprop:Generator_UserColumnName="Username" msprop:Generator_ColumnVarNameInTable="columnUsername" msprop:Generator_ColumnPropNameInRow="Username" msprop:Generator_ColumnPropNameInTable="UsernameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FirstName" msprop:Generator_UserColumnName="FirstName" msprop:Generator_ColumnVarNameInTable="columnFirstName" msprop:Generator_ColumnPropNameInRow="FirstName" msprop:Generator_ColumnPropNameInTable="FirstNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LastName" msprop:Generator_UserColumnName="LastName" msprop:Generator_ColumnVarNameInTable="columnLastName" msprop:Generator_ColumnPropNameInRow="LastName" msprop:Generator_ColumnPropNameInTable="LastNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="StudentIDNumber" msprop:Generator_UserColumnName="StudentIDNumber" msprop:Generator_ColumnVarNameInTable="columnStudentIDNumber" msprop:Generator_ColumnPropNameInRow="StudentIDNumber" msprop:Generator_ColumnPropNameInTable="StudentIDNumberColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Year" msprop:Generator_UserColumnName="Year" msprop:Generator_ColumnVarNameInTable="columnYear" msprop:Generator_ColumnPropNameInRow="Year" msprop:Generator_ColumnPropNameInTable="YearColumn" type="xs:int" minOccurs="0" />
              <xs:element name="StartedDateTime" msprop:Generator_UserColumnName="StartedDateTime" msprop:Generator_ColumnPropNameInRow="StartedDateTime" msprop:Generator_ColumnVarNameInTable="columnStartedDateTime" msprop:Generator_ColumnPropNameInTable="StartedDateTimeColumn" type="xs:dateTime" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Assignments_Submission_Essay" msprop:Generator_UserTableName="Assignments_Submission_Essay" msprop:Generator_RowDeletedName="Assignments_Submission_EssayRowDeleted" msprop:Generator_RowChangedName="Assignments_Submission_EssayRowChanged" msprop:Generator_RowClassName="Assignments_Submission_EssayRow" msprop:Generator_RowChangingName="Assignments_Submission_EssayRowChanging" msprop:Generator_RowEvArgName="Assignments_Submission_EssayRowChangeEvent" msprop:Generator_RowEvHandlerName="Assignments_Submission_EssayRowChangeEventHandler" msprop:Generator_TableClassName="Assignments_Submission_EssayDataTable" msprop:Generator_TableVarName="tableAssignments_Submission_Essay" msprop:Generator_RowDeletingName="Assignments_Submission_EssayRowDeleting" msprop:Generator_TablePropName="Assignments_Submission_Essay">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="EssaySubmissionID" msprop:Generator_UserColumnName="EssaySubmissionID" msprop:Generator_ColumnVarNameInTable="columnEssaySubmissionID" msprop:Generator_ColumnPropNameInRow="EssaySubmissionID" msprop:Generator_ColumnPropNameInTable="EssaySubmissionIDColumn" type="xs:int" />
              <xs:element name="AssignmentID" msprop:Generator_UserColumnName="AssignmentID" msprop:Generator_ColumnVarNameInTable="columnAssignmentID" msprop:Generator_ColumnPropNameInRow="AssignmentID" msprop:Generator_ColumnPropNameInTable="AssignmentIDColumn" type="xs:int" />
              <xs:element name="UserID" msprop:Generator_UserColumnName="UserID" msprop:Generator_ColumnVarNameInTable="columnUserID" msprop:Generator_ColumnPropNameInRow="UserID" msprop:Generator_ColumnPropNameInTable="UserIDColumn" type="xs:int" />
              <xs:element name="StudentAnswer" msprop:Generator_UserColumnName="StudentAnswer" msprop:Generator_ColumnVarNameInTable="columnStudentAnswer" msprop:Generator_ColumnPropNameInRow="StudentAnswer" msprop:Generator_ColumnPropNameInTable="StudentAnswerColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IsFinal" msprop:Generator_UserColumnName="IsFinal" msprop:Generator_ColumnVarNameInTable="columnIsFinal" msprop:Generator_ColumnPropNameInRow="IsFinal" msprop:Generator_ColumnPropNameInTable="IsFinalColumn" type="xs:boolean" />
              <xs:element name="Grade" msprop:Generator_UserColumnName="Grade" msprop:Generator_ColumnVarNameInTable="columnGrade" msprop:Generator_ColumnPropNameInRow="Grade" msprop:Generator_ColumnPropNameInTable="GradeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TimeStamp" msprop:Generator_UserColumnName="TimeStamp" msprop:Generator_ColumnVarNameInTable="columnTimeStamp" msprop:Generator_ColumnPropNameInRow="TimeStamp" msprop:Generator_ColumnPropNameInTable="TimeStampColumn" type="xs:dateTime" />
              <xs:element name="SubmittedDateTime" msprop:Generator_UserColumnName="SubmittedDateTime" msprop:Generator_ColumnVarNameInTable="columnSubmittedDateTime" msprop:Generator_ColumnPropNameInRow="SubmittedDateTime" msprop:Generator_ColumnPropNameInTable="SubmittedDateTimeColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="CourseID" msprop:Generator_UserColumnName="CourseID" msprop:Generator_ColumnVarNameInTable="columnCourseID" msprop:Generator_ColumnPropNameInRow="CourseID" msprop:Generator_ColumnPropNameInTable="CourseIDColumn" type="xs:int" />
              <xs:element name="SectionNumber" msprop:Generator_UserColumnName="SectionNumber" msprop:Generator_ColumnVarNameInTable="columnSectionNumber" msprop:Generator_ColumnPropNameInRow="SectionNumber" msprop:Generator_ColumnPropNameInTable="SectionNumberColumn" type="xs:int" />
              <xs:element name="StandardID" msprop:Generator_UserColumnName="StandardID" msprop:Generator_ColumnVarNameInTable="columnStandardID" msprop:Generator_ColumnPropNameInRow="StandardID" msprop:Generator_ColumnPropNameInTable="StandardIDColumn" type="xs:int" />
              <xs:element name="Username" msprop:Generator_UserColumnName="Username" msprop:Generator_ColumnVarNameInTable="columnUsername" msprop:Generator_ColumnPropNameInRow="Username" msprop:Generator_ColumnPropNameInTable="UsernameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FirstName" msprop:Generator_UserColumnName="FirstName" msprop:Generator_ColumnVarNameInTable="columnFirstName" msprop:Generator_ColumnPropNameInRow="FirstName" msprop:Generator_ColumnPropNameInTable="FirstNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LastName" msprop:Generator_UserColumnName="LastName" msprop:Generator_ColumnVarNameInTable="columnLastName" msprop:Generator_ColumnPropNameInRow="LastName" msprop:Generator_ColumnPropNameInTable="LastNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="StudentIDNumber" msprop:Generator_UserColumnName="StudentIDNumber" msprop:Generator_ColumnVarNameInTable="columnStudentIDNumber" msprop:Generator_ColumnPropNameInRow="StudentIDNumber" msprop:Generator_ColumnPropNameInTable="StudentIDNumberColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Year" msprop:Generator_UserColumnName="Year" msprop:Generator_ColumnVarNameInTable="columnYear" msprop:Generator_ColumnPropNameInRow="Year" msprop:Generator_ColumnPropNameInTable="YearColumn" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Assignments_Submission_Essay_Comments" msprop:Generator_UserTableName="Assignments_Submission_Essay_Comments" msprop:Generator_RowDeletedName="Assignments_Submission_Essay_CommentsRowDeleted" msprop:Generator_RowChangedName="Assignments_Submission_Essay_CommentsRowChanged" msprop:Generator_RowClassName="Assignments_Submission_Essay_CommentsRow" msprop:Generator_RowChangingName="Assignments_Submission_Essay_CommentsRowChanging" msprop:Generator_RowEvArgName="Assignments_Submission_Essay_CommentsRowChangeEvent" msprop:Generator_RowEvHandlerName="Assignments_Submission_Essay_CommentsRowChangeEventHandler" msprop:Generator_TableClassName="Assignments_Submission_Essay_CommentsDataTable" msprop:Generator_TableVarName="tableAssignments_Submission_Essay_Comments" msprop:Generator_RowDeletingName="Assignments_Submission_Essay_CommentsRowDeleting" msprop:Generator_TablePropName="Assignments_Submission_Essay_Comments">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="EssaySubmissionID" msprop:Generator_UserColumnName="EssaySubmissionID" msprop:Generator_ColumnVarNameInTable="columnEssaySubmissionID" msprop:Generator_ColumnPropNameInRow="EssaySubmissionID" msprop:Generator_ColumnPropNameInTable="EssaySubmissionIDColumn" type="xs:int" />
              <xs:element name="InstructorUserID" msprop:Generator_UserColumnName="InstructorUserID" msprop:Generator_ColumnVarNameInTable="columnInstructorUserID" msprop:Generator_ColumnPropNameInRow="InstructorUserID" msprop:Generator_ColumnPropNameInTable="InstructorUserIDColumn" type="xs:int" />
              <xs:element name="Comment" msprop:Generator_UserColumnName="Comment" msprop:Generator_ColumnVarNameInTable="columnComment" msprop:Generator_ColumnPropNameInRow="Comment" msprop:Generator_ColumnPropNameInTable="CommentColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TimeStamp" msprop:Generator_UserColumnName="TimeStamp" msprop:Generator_ColumnVarNameInTable="columnTimeStamp" msprop:Generator_ColumnPropNameInRow="TimeStamp" msprop:Generator_ColumnPropNameInTable="TimeStampColumn" type="xs:dateTime" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Assignments" />
      <xs:field xpath="mstns:AssignmentID" />
    </xs:unique>
    <xs:unique name="QuizAssignments_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:QuizAssignments" />
      <xs:field xpath="mstns:AssignmentID" />
    </xs:unique>
    <xs:unique name="Relations_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Relations" />
      <xs:field xpath="mstns:AssignmentID" />
      <xs:field xpath="mstns:CourseID" />
      <xs:field xpath="mstns:SectionNumber" />
      <xs:field xpath="mstns:StandardID" />
    </xs:unique>
    <xs:unique name="Assignments_Quiz_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Assignments_Quiz" />
      <xs:field xpath="mstns:AssignmentID" />
    </xs:unique>
    <xs:unique name="Assignments_Submission_Quiz_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Assignments_Submission_Quiz" />
      <xs:field xpath="mstns:QuizSubmissionID" />
    </xs:unique>
    <xs:unique name="Assignments_Submission_Essay_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Assignments_Submission_Essay" />
      <xs:field xpath="mstns:EssaySubmissionID" />
    </xs:unique>
    <xs:unique name="Assignments_Submission_Essay_Comments_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Assignments_Submission_Essay_Comments" />
      <xs:field xpath="mstns:EssaySubmissionID" />
      <xs:field xpath="mstns:InstructorUserID" />
    </xs:unique>
    <xs:keyref name="FK_Assignments_Submission_Essay_Assignments_Submission_Essay_Comments" refer="Assignments_Submission_Essay_Constraint1" msprop:rel_Generator_UserRelationName="FK_Assignments_Submission_Essay_Assignments_Submission_Essay_Comments" msprop:rel_Generator_RelationVarName="relationFK_Assignments_Submission_Essay_Assignments_Submission_Essay_Comments" msprop:rel_Generator_UserChildTable="Assignments_Submission_Essay_Comments" msprop:rel_Generator_UserParentTable="Assignments_Submission_Essay" msprop:rel_Generator_ParentPropName="Assignments_Submission_EssayRow" msprop:rel_Generator_ChildPropName="GetAssignments_Submission_Essay_CommentsRows">
      <xs:selector xpath=".//mstns:Assignments_Submission_Essay_Comments" />
      <xs:field xpath="mstns:EssaySubmissionID" />
    </xs:keyref>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_Assignments_Quiz-Assignments" msdata:parent="Assignments" msdata:child="QuizAssignments" msdata:parentkey="AssignmentID" msdata:childkey="AssignmentID" msprop:Generator_UserRelationName="FK_Assignments_Quiz-Assignments" msprop:Generator_RelationVarName="_relationFK_Assignments_Quiz_Assignments" msprop:Generator_UserChildTable="QuizAssignments" msprop:Generator_UserParentTable="Assignments" msprop:Generator_ParentPropName="AssignmentsRow" msprop:Generator_ChildPropName="GetQuizAssignmentsRows" />
      <msdata:Relationship name="FK_Relations_Assignments_Courses_Section-Assignments" msdata:parent="Assignments" msdata:child="Relations" msdata:parentkey="AssignmentID" msdata:childkey="AssignmentID" msprop:Generator_UserRelationName="FK_Relations_Assignments_Courses_Section-Assignments" msprop:Generator_RelationVarName="_relationFK_Relations_Assignments_Courses_Section_Assignments" msprop:Generator_UserChildTable="Relations" msprop:Generator_UserParentTable="Assignments" msprop:Generator_ParentPropName="AssignmentsRow" msprop:Generator_ChildPropName="GetRelationsRows" />
      <msdata:Relationship name="FK_Relations_Assignments_Courses_Section-Assignments1" msdata:parent="QuizAssignments" msdata:child="Relations" msdata:parentkey="AssignmentID" msdata:childkey="AssignmentID" msprop:Generator_UserRelationName="FK_Relations_Assignments_Courses_Section-Assignments1" msprop:Generator_RelationVarName="_relationFK_Relations_Assignments_Courses_Section_Assignments1" msprop:Generator_UserChildTable="Relations" msprop:Generator_UserParentTable="QuizAssignments" msprop:Generator_ParentPropName="Assignments_QuizRow" msprop:Generator_ChildPropName="GetRelationsRows" />
      <msdata:Relationship name="FK_Assignments_Quiz-Assignments1" msdata:parent="Assignments" msdata:child="Assignments_Quiz" msdata:parentkey="AssignmentID" msdata:childkey="AssignmentID" msprop:Generator_UserRelationName="FK_Assignments_Quiz-Assignments1" msprop:Generator_RelationVarName="_relationFK_Assignments_Quiz_Assignments1" msprop:Generator_UserChildTable="Assignments_Quiz" msprop:Generator_UserParentTable="Assignments" msprop:Generator_ParentPropName="AssignmentsRow" msprop:Generator_ChildPropName="GetAssignments_QuizRows" />
      <msdata:Relationship name="FK_Assignments_Quiz-Assignments2" msdata:parent="QuizAssignments" msdata:child="Assignments_Quiz" msdata:parentkey="AssignmentID" msdata:childkey="AssignmentID" msprop:Generator_UserRelationName="FK_Assignments_Quiz-Assignments2" msprop:Generator_RelationVarName="_relationFK_Assignments_Quiz_Assignments2" msprop:Generator_UserChildTable="Assignments_Quiz" msprop:Generator_UserParentTable="QuizAssignments" msprop:Generator_ParentPropName="QuizAssignmentsRow" msprop:Generator_ChildPropName="GetAssignments_QuizRows" />
      <msdata:Relationship name="FK_Assignments_Submission_Quiz-Assignments" msdata:parent="Assignments" msdata:child="Assignments_Submission_Quiz" msdata:parentkey="AssignmentID" msdata:childkey="AssignmentID" msprop:Generator_UserRelationName="FK_Assignments_Submission_Quiz-Assignments" msprop:Generator_RelationVarName="_relationFK_Assignments_Submission_Quiz_Assignments" msprop:Generator_UserChildTable="Assignments_Submission_Quiz" msprop:Generator_UserParentTable="Assignments" msprop:Generator_ParentPropName="AssignmentsRow" msprop:Generator_ChildPropName="GetAssignments_Submission_QuizRows" />
      <msdata:Relationship name="FK_Assignments_Submission_Essay-Assignments" msdata:parent="Assignments" msdata:child="Assignments_Submission_Essay" msdata:parentkey="AssignmentID" msdata:childkey="AssignmentID" msprop:Generator_UserRelationName="FK_Assignments_Submission_Essay-Assignments" msprop:Generator_RelationVarName="_relationFK_Assignments_Submission_Essay_Assignments" msprop:Generator_UserChildTable="Assignments_Submission_Essay" msprop:Generator_UserParentTable="Assignments" msprop:Generator_ParentPropName="AssignmentsRow" msprop:Generator_ChildPropName="GetAssignments_Submission_EssayRows" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>